snowflake schema

См. также в других словарях:

• Snowflake schema — A snowflake schema is a logical arrangement of tables in a relational database such that the entity relationship diagram resembles a snowflake in shape. Closely related to the star schema, the snowflake schema is represented by centralized fact… …   Wikipedia

• Snowflake-Schema — Das Schneeflockenschema ist eine Weiterführung des Sternschemas, das beim OLAP und Data Warehousing eingesetzt wird. Beim Sternschema liegen die Dimensionstabellen denormalisiert vor, was eine bessere Verarbeitungsgeschwindigkeit zu Lasten der… …   Deutsch Wikipedia

• Snowflake Schema — Das Schneeflockenschema ist eine Weiterführung des Sternschemas, das beim OLAP und Data Warehousing eingesetzt wird. Beim Sternschema liegen die Dimensionstabellen denormalisiert vor, was eine bessere Verarbeitungsgeschwindigkeit zu Lasten der… …   Deutsch Wikipedia

• Snowflake — may refer to:* A particle of snow * Snowflake (albino gorilla) * Snowflake (plant), flowering plants in the genus Leucojum * Snowflake, Arizona * Snowflake schema, a concept in data management * Snowflake children, a child conceived through in… …   Wikipedia

• Star schema — The star schema (sometimes referenced as star join schema) is the simplest style of data warehouse schema. The star schema consists of a few fact tables (possibly only one, justifying the name) referencing any number of dimension tables . The… …   Wikipedia

• Schneeflockenschema — Schneeflockenschema: Fakt und Dimensionstabellen bilden eine schneeflockenförmige Struktur und werden im Unterschied zum Star Schema weiter verfeinert und normalisiert Das Schneeflockenschema ist eine Weiterführung des Sternschemas, das beim OLAP …   Deutsch Wikipedia

• Dimensional database — A dimensional database is one which, rather than representing data in multiple relations (as a relational database does), represents key data entities as different dimensions. That is, multidimensional database systems offer an extension to the… …   Wikipedia

• Data model — Overview of data modeling context: A data model provides the details of information to be stored, and is of primary use when the final product is the generation of computer software code for an application or the preparation of a functional… …   Wikipedia

• Data warehouse — Overview In computing, a data warehouse (DW) is a database used for reporting and analysis. The data stored in the warehouse is uploaded from the operational systems. The data may pass through an operational data store for additional operations… …   Wikipedia

• Online analytical processing — In computing, online analytical processing, or OLAP (  /ˈoʊlæ …   Wikipedia

• Data mart — A data mart (DM) is the access layer of the data warehouse (DW) environment that is used to get data out to the users. The DM is a subset of the DW, usually oriented to a specific business line or team. Contents 1 Terminology 2 Design schemas 3… …   Wikipedia